Owner

dbo

Creation Date

10-07-2003 10:31:35

Remarks

Columns

Key	Id	Name	Type	Length	IsNullable	Collation
		ProductID	int	4
		ProductName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
		ProductName	sysname	80		SQL_Latin1_General_CP1_CI_AS
		SupplierID	int	4
		CategoryID	int	4
		QuantityPerUnit	nvarchar	40		SQL_Latin1_General_CP1_CI_AS
		QuantityPerUnit	sysname	40		SQL_Latin1_General_CP1_CI_AS
		UnitPrice	money	8
		UnitsInStock	smallint	2
		UnitsOnOrder	smallint	2
		ReorderLevel	smallint	2
		Discontinued	bit	1

Indexes

Name	Description	Group	Keys
PK_Products	clustered, unique, primary key	PRIMARY	ProductID
CategoriesProducts	nonclustered	PRIMARY	CategoryID
CategoryID	nonclustered	PRIMARY	CategoryID
ProductName	nonclustered	PRIMARY	ProductName
SupplierID	nonclustered	PRIMARY	SupplierID
SuppliersProducts	nonclustered	PRIMARY	SupplierID

Relations

Categories CategoryID

Products   CategoryID

Suppliers SupplierID

Products   SupplierID

Products ProductID

Order Details   ProductID